package cn.itcast.tlias.com.tliaswork;

import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.boot.web.servlet.ServletComponentScan;

/**
 * DROP TABLE IF EXISTS dept;
 DROP TABLE IF EXISTS emp;

 CREATE table dept(
 id INT PRIMARY KEY AUTO_INCREMENT COMMENT '主键',
 name VARCHAR(10) NOT NULL  UNIQUE COMMENT '部门名称',
 create_time DATETIME not NULL COMMENT '创建时间',
 update_time DATETIME NOT NULL COMMENT '修改时间'
 )COMMENT '部门表';

 INSERT INTO dept (id, name, create_time, update_time) VALUES
 (1,'学工部',NOW(),NOW()),
 (2,'教研部',NOW(),NOW()),
 (3,'咨询部',NOW(),NOW());

 CREATE TABLE emp(
 id INT PRIMARY KEY AUTO_INCREMENT COMMENT 'ID',
 username VARCHAR(20) NOT NULL UNIQUE COMMENT '用户名',
 password VARCHAR(32) DEFAULT '123456' COMMENT '密码',
 name VARCHAR(10) NOT NULL COMMENT '姓名',
 gender TINYINT UNSIGNED NOT NULL COMMENT '性别,说明:1男,2女',
 image VARCHAR(300) COMMENT '图像',
 job TINYINT UNSIGNED COMMENT '职位,说明:1班主任,2讲师,3学工主管,4教研主管,5咨询师',
 entrydate DATE COMMENT '入职时间',
 dept_id INT UNSIGNED COMMENT '入职时间',
 create_time DATETIME NOT NULL  COMMENT '创建时间',
 uptate_time DATETIME NOT NULL COMMENT '修改时间'
 );

 INSERT INTO emp(id, username, password, name, gender, image, job, entrydate, dept_id, create_time, uptate_time) VALUES
 (1,'jinyong','123456','金庸',1,'1.jpg',4,'2000-01-01',2,now() , now()),
 (2,'zhangwuji','123456','张无忌',1,'2.jpg',2,'2015-01-01',2,now(),now()),
 (3,'yangxiao','123456','杨逍',1,'3.jpg',2,'2008-05-01',2,now(),now()),
 (4, 'weiyixiao','123456','韦一笑',1,'4.jpg',2,'2007-01-01',2,now(), now()),
 (5, 'changyuchun','123456','常遇春',1,'5.jpg',2,'2012-12-05',2,now(),now()),
 (6, 'xiaozhao', '123456','小昭',2,'6.jpg',3,'2013-09-05',1,now(),now()),
 (7,'jixiaofu', '123456','纪晓芙',2,'7.jpg',1,'2005-08-01',1,now(),now()),
 (8,'zhouzhiruo','123456','周芷若',2,'8.jpg',1,'2014-11-09',1,now(),now()),
 (9,'dingminjun','123456','丁敏君',2,'9.jpg',1,'2011-03-11',1,now(),now()),
 (10,'zhaomin','123456','赵敏',2,'10.jpg',1,'2013-09-05',1,now(),now()),
 (11,'luzhangke','123456','鹿杖客',1,'11.jpg',5,'2007-02-01',3,now(), now()),
 (12,'hebiweng','123456','鹤笔翁',1,'12.jpg',5,'2008-08-18',3,now(),now()),
 (13,'fangdongbai','123456','方东白',1,'13.jpg',5,'2012-11-01',3,now(), now()),
 (14, 'zhangsanfeng','123456', '张三丰',1,'14.jpg',2,'2002-08-01',2, now() , now()),
 (15, 'yulianzhou','123456','俞莲舟',1,'15.jpg',2,'2011-05-01',2,now() ,now()),
 (16, 'songyuanqiao','123456','宋远桥',1,'16.jpg',2,'2007-01-01',2,now(), now()),
 (17, 'chenyouliang','123456','陈友谅',1,'17.jpg',NULL,'2015-03-21',NULL, now(),now());
 */

/**
 * CREATE TABLE dept_log( id INT PRIMARY KEY AUTO_INCREMENT,
 create_time DATE,
 description VARCHAR(100)
 )
 */
@ServletComponentScan  //声明Spring关联Filter注册器
@SpringBootApplication
public class TliasworkApplication {

	public static void main(String[] args) {
		SpringApplication.run(TliasworkApplication.class, args);
	}

}
